<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
	<sql-query name="Contents.ListContentsMedia">
	<return alias="cm" class="com.nts.visionworks.business.contents.domain.ContentsMedia"></return>
	<return alias="ac" class="com.nts.visionworks.core.multipart.domain.Archive"></return>
	SELECT
		cm.MediaId,
		cm.MediaDetails,
		ac.*
	FROM
		contents_media AS cm
		INNER JOIN archive AS ac
		ON cm.archiveId = ac.archiveId
	</sql-query>
</hibernate-mapping>